The trust ledger nobody wants to reconcile

There is a task in every independent agency that falls to whoever is most careful and least able to say no. At my old agency it was Pat, who had been with us nineteen years. On the third business day of each month she closed her door and reconciled the premium trust account. Nobody knocked.

The trust account holds money that is not the agency’s. An insured pays a down payment or an installment; the agency holds it and remits it to the carrier. In between, the agency is a fiduciary, and the state expects it to be able to say, for any dollar on any day, whose it is.

Why it goes wrong slowly

Trust accounting rarely fails dramatically. It drifts. A payment arrives by check with a policy number that is one digit off. A customer pays two installments at once. A card payment is posted to the account but nobody receipts it to the policy until the following week. Each of these is a small thing. Thirty of them make a reconciliation that takes two days and ends with a line called “unidentified.”

Examiners look for that line. So do carriers, during an agency review.

Match on the day, not at month end

The fix is not cleverness. It is timing. A payment that is matched to its policy the day it arrives is easy to match, because the customer, the amount and the reason are all fresh. The same payment three weeks later is a puzzle.

That is what Bevel’s fifth operation does. When a payment posts, it is matched to a policy using the amount, the payer and the installment schedule, not only the reference number someone typed. Then three things happen.

• A receipt goes to the insured.
• The payment is recorded against the policy in the management system.
• The trust ledger gets a line: date received, insured, policy, carrier, amount, and the date it is due to be remitted.

When Bevel cannot match a payment with confidence, it does not guess. The payment sits in Needs review with the two or three policies it might belong to, and a person picks. Across the agencies using this operation, that is about one payment in forty.

What month end looks like afterward

If every payment has been matched daily, the monthly reconciliation is no longer an investigation. It is a comparison of two totals that should already agree, plus a short list of items in transit. Agencies that switch this operation on report the job going from a day or two to under an hour.

For agencies with more than one office, each office can keep its own ledger. Thornbury Group runs three, one each for Omaha, Lincoln and Council Bluffs, and the daily line for each lands in the same report.

Try the daily habit first

As with most things we build, you can test the idea with no software at all. For two weeks, have one person match every payment to its policy before they go home, and keep a simple log with the six columns above. Then do your month-end reconciliation and time it.

If it took half as long, you have learned that your trust problem is a timing problem, which is the good kind. If it did not, you have a different problem, and you should call your accountant before you call us.

Pat retired in 2023. Her advice to her replacement was four words: do it every day.

She was right, and she had been right for nineteen years. All we have done is make “every day” something that happens whether or not anyone remembers.